<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE topic PUBLIC "-//OASIS//DTD DITA Topic//EN" "topic.dtd">
<topic id="topic_vcn_jkq_1bb">
 <title>hstore</title>
 <body>
  <p>The <codeph>hstore</codeph> module implements a data type for storing sets of (key,value) pairs
   within a single Greenplum Database data field. This can be useful in various scenarios, such as
   rows with many attributes that are rarely examined, or semi-structured data.</p>
  <p>The Greenplum Database <codeph>hstore</codeph> module is equivalent
   to the PostgreSQL <codeph>hstore</codeph> module. There are no
   Greenplum Database or MPP-specific considerations for the module.</p>
 </body>
 <topic id="topic_reg">
    <title>Installing and Registering the Module</title>
    <body>
      <p>The <codeph>hstore</codeph> module is installed when you install
        Greenplum Database. Before you can use any of the data types or functions
        defined in the module, you must register the <codeph>hstore</codeph> extension
        in each database in which you want to use the objects.
        <ph otherprops="pivotal">Refer to <xref href="../../install_guide/install_modules.html"
          format="html" scope="external">Installing Additional Supplied Modules</xref>
        for more information.</ph></p>
    </body>
  </topic>
  <topic id="topic_info">
    <title>Module Documentation</title>
    <body>
      <p>See <xref href="https://www.postgresql.org/docs/9.4/hstore.html"
        format="html" scope="external">hstore</xref> in the PostgreSQL
        documentation for detailed information about the data types and
        functions defined in this module.</p>
    </body>
  </topic>
</topic>
